Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RewardID (FK) | A token identifier for a Reward instance. | ID_RWD | Identity | integer | RewardDerivationRule(RU_RWD_DRVN_RU) |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | |
CustomerMembeshiprProgramAccountID (FK) | Token ID for a CustomerMemberProgramAccount. | ID_CT_MBR_PRGM_ACNT | Identity | integer | CustomerAccountRewardTierStatus(CO_CT_ACNT_RWD_TR_STS) |
CustomerRewardProgramTierCode (FK) | A code that represents the relative value of a given CustomerRewardProgramTier | CD_CT_RWD_PRGM_TIER | Code | varchar(20) | CustomerAccountRewardTierStatus(CO_CT_ACNT_RWD_TR_STS) |
MembershipProgramID (FK) | Token ID for a CustomerRewardProgram instance. | ID_CT_MBRSHP_PRGM | Identity | integer | CustomerAccountRewardTierStatus(CO_CT_ACNT_RWD_TR_STS) |
LevelNumber (FK) | A whole number that establishes the relative value of a membership program level. The higher the value, the greater the level and its associated rewards and, where applicable, fees. | IC_LV_NMB | Number | integer | CustomerAccountRewardTierStatus(CO_CT_ACNT_RWD_TR_STS) |
RewardActionCode | A code that defines how deferred rewards are to be processed in this line item. Valid values: EARN - translate sale/return infor into reward currency REDEEM - translate the reward currency into a discount or rebate value (percent off or monetary value) for use in the current transaction ADJUST - add to or subtract from a redeemed currency balance held in the membership program account referenced in this entity type instance. NOTE: Keep in mind that a Reward may be earned and redeemed in the same retail transaction. Instant rebates are one example of this. When a reward is earned AND redeemed in the same retail transaction, there will be TWO CustomerRewardLineItem (and for rebates CustomerRewardRebateLine instances) in that transaction. The first for an earned reward and the second for a redeemed reward. | CD_RWD_ACTN | Code | varchar(20) | |
RewardID (FK) | A token identifier for a Reward instance. | ID_RWD | Identity | integer | Reward(TR_RWD) |
RewardDerivationSequenceNumber (FK) | A sequence number used to specify the order for applying derivation rules tied to a Reward. RewardDerivationSequenceNumber always starts with 1 and is incremented by 1 for each appended derivation step tied to the Reward. | AI_RWD_DRVN_SQN_NMB | LineNumber | integer | RewardDerivationRule(RU_RWD_DRVN_RU) |
RewardValueAmount | The numeric value of a RewardLineItem expressed in reward currency units. Reward currency unit examples include: MONEY (discount amount or pct off) POINTS MILES MEALS Any other units a retailer chooses to reflect a stored, accrued value based on customer purchases as defeined in RewardDerivationRule.CustomerAccountValuationUnitTypeCode. | MO_RWD_VL_AMT | Money | decimal(16,5) | |
CustomerAccountValuationUnitTypeCode (FK) | A code that identifies a kind of valuation unit. Examples include: MONEY POINTS MILES GALLONS VISITS others that are relevant to a retailer | CD_CT_ACNT_VLN_UN_TYP | Code | varchar(20) | CustomerAccountValuationUnitType(CO_CT_ACNT_VLN_UN_TYP) |
StatusSequencNumber (FK) | A sequence number used to capture a customer's program account reward tier status change, This attribute allows multiple occurences of a tier status to be stored over time for time series analysis of customer activity. | AI_STS_SQN_NMB | Identity | integer | CustomerAccountRewardTierStatus(CO_CT_ACNT_RWD_TR_STS) |